package com.nus.fellowmark.dao;

import com.nus.fellowmark.entity.ReviewEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * 
 * 
 * @author Goh Yen Ther
 * @email goh.yenther@gmail.com
 * @date 2023-03-04 
 */
@Mapper
public interface ReviewDao extends BaseMapper<ReviewEntity> {
	/**
     * select review by pairingId and submissionId
     * @param (pairingId,submissionId)
     * @return
     */
    @Select("SELECT * FROM review WHERE pairing_id=#{pairingId} AND submission_id=#{submissionId}")
    ReviewEntity selectByPairAndSubmission(Integer pairingId, Integer submissionId);
}